package com.bond.dao;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

/**
 * 项目启动时建表，如果表不存在就创建
 */
@Mapper
public interface SysInitMapper {

    @Update("CREATE TABLE IF NOT EXISTS device_info (id INTEGER,name TEXT,work_number TEXT,device_id TEXT,create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(id AUTOINCREMENT))")
    int createTableDeviceInfo();

    @Update("CREATE TABLE IF NOT EXISTS scan_req_info (id INTEGER,msg TEXT,device_id TEXT,name TEXT,work_number TEXT,create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(id AUTOINCREMENT))")
    int createTableScanReqInfo();
}
